The SYSERR automatic macro variable might not be set to a nonzero value when the IMPORT procedure fails. The problem occurs under the following circumstances:

• If you are running SAS in batch mode rather than interactive mode
• If the error in the IMPORT procedure occurs when reading a nonexistent sheet

    proc import datafile='c:\sastest\myexcel.xls' 
     out=sastest  
     dbms=xls;
     sheet='barney';
run;

Requested Sheet Name not found on Excel -> c:\sastest\myexcel.xls
Requested Input File Is Invalid
ERROR: Import unsuccessful.  See SAS Log for details.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds


    %put &syserr;
0

In this example, the correct value of SYSERR is 1012.

A fix for this issue is planned for a future release.

Operating System and Release Information